﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Collections;

  public  class DbAccess
    {
       
       
        public DataSet getMobile(string mobile)
        {
            try
            {
                // Get the employee details
                string strSql = "SELECT * from list where [num]='"+mobile+"'";
                OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=080911.mdb");
                objConn.Open();
                OleDbDataAdapter dat = new OleDbDataAdapter(strSql, objConn);
                DataSet ds = new DataSet();
                dat.Fill(ds);
                objConn.Close();
                return ds;
            }
            catch (Exception Ex)
            {
                throw Ex;
            }

        }
    }


